if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_Items]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[vw_Items]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE VIEW dbo.vw_Items
AS
SELECT     dbo.Items.GroupID, dbo.Groups.GroupCode, dbo.Groups.GroupName, dbo.Groups.GroupNameUrdu, dbo.Groups.Type, dbo.Groups.Scale, dbo.Items.ItemID, 
                      dbo.Items.ItemCode, dbo.Items.ItemName, dbo.Items.ItemNameUrdu, dbo.Items.Discontinue, dbo.Items.PRate, dbo.Items.SRate, dbo.Items.ArticleNo, 
                      dbo.Items.Margin, dbo.Items.Opening, dbo.Items.InUnit, dbo.Varietys.VarietyID, dbo.Varietys.VarietyCode, dbo.Varietys.VarietyName, 
                      dbo.Varietys.VarietyNameUrdu
FROM         dbo.Varietys RIGHT OUTER JOIN
                      dbo.Items ON dbo.Varietys.ItemID = dbo.Items.ItemID LEFT OUTER JOIN
                      dbo.Groups ON dbo.Items.GroupID = dbo.Groups.GroupID

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


--------------------------------------------------------